SQL Examples:

Update Place by a Ribbon or Ribbon by a Place:
UPDATE Entries SET Place = 1 WHERE Ribbon="Blue"
UPDATE Entries SET Ribbon = "Blue" WHERE Place = 1
UPDATE Entries SET Ribbon = IIf([Place]=1,"Blue","Green")
UPDATE Entries SET Ribbon = IIf([Place]=1,"Blue",IIf([Place]=2,"Red",IIf([Place]=3,"White","Green")))

Update the Class of steers at a certain weight:
UPDATE Entries SET Class="Medium" WHERE Division="Market Steers" AND [Show Weight] BETWEEN 1000 AND 1100

Delete entries:
DELETE * FROM Entries
DELETE * FROM Entries WHERE Division = 'Market Steers'

Backup Show Weight (copy the value into the Check-in Weight field)
UPDATE Entries SET [Check-in Weight] = [Show Weight]

Restore Show Weight
UPDATE Entries SET [Show Weight] = [Check-in Weight]

Round Sale Weight
UPDATE x_EntriesDataEntry SET [Show Weight] = Round([Sale Weight],0)
UPDATE Divisions SET [% Shrink] = 0

Set the Sale Order of entries that didn't make the sale, to 999 so that they can be bought after the sale
UPDATE Entries SET [Sale Order]=999 WHERE [Sale Order] Is Null

Update the Status of an exhibitor based on their age:
UPDATE Exhibitors SET Status = "Junior" WHERE [Exhibitor Date of Birth] > #1/1/2008#
UPDATE Exhibitors SET Status = "Sophomore" WHERE [Exhibitor Date of Birth] BETWEEN #1/1/2008# AND #9/1/2008#

Update all the Exhibitor (or Buyer, or Clubs, etc) passwords:
UPDATE Exhibitors SET [Exhibitor Password]="foobar"
UPDATE Exhibitors SET [Exhibitor Password]=Right([Zip Code],4)

To unmask or mask the passwords:
UPDATE tblOptions SET [Mask Passwords]=False
UPDATE tblOptions SET [Mask Passwords]=True

The SSN masking can be done similar:
UPDATE tblOptions SET [Mask SS#]=False
UPDATE tblOptions SET [Mask SS#]=True

===================TRY ON YOUR OWN TO EXPLAIN WHAT EACH SQL STATEMENT DOES BELOW===============

UPDATE Entries SET Place=1 WHERE Ribbon="Blue"

UPDATE Entries SET [Premium - Place] = [Premium - Place] * 1.5 WHERE [Division]='Market Steers'

UPDATE Entries SET [Class]=Null WHERE [Division]='Market Steers'

UPDATE Entries SET [Show Weight]=Null WHERE [Division]='Market Goats'

UPDATE Entries SET [Show Weight]=[Check-in Weight] WHERE [Division]='Market Goats' AND [Show Weight] IS NULL

UPDATE Entries SET [Show Weight]=[Check-in Weight] WHERE [Division]='Market Goats' AND ([Show Weight] IS NULL OR [Show Weight]>[Check-in Weight])

UPDATE Entries SET [Block from Sale]=True WHERE [UDEntry-Checkbox1]=True

UPDATE Entries SET [Block from Sale]=[UDEntry-Checkbox1]

UPDATE Exhibitors SET [Status]='Youth' WHERE [Exhibitor Date of Birth]>=#9/1/2006#

DELETE * FROM [Sale Adjustments]

DELETE * FROM [Sale Adjustments] WHERE [Sale Adjustment Name]='Beef Check-off'

DELETE * FROM [Sale Adjustments] WHERE [Sale Adjustment Amount] BETWEEN 0 AND 100

DELETE * FROM [Exhibitor Fees]

SELECT * FROM Entries

SELECT Count(*) FROM Entries

SELECT Sum([Points - Place]) FROM Entries

SELECT Sum([Points - Place]) FROM Entries WHERE [Division]='Junior Heifers'

SELECT Sum([Points - Place]) AS [Total Points], [Division] FROM Entries GROUP BY [Division]

SELECT Count(*) AS [Total Entries], [Division] FROM Entries GROUP BY [Division]

SELECT Count(*) AS [Total Entries], [Division] FROM Entries WHERE [Place] IS NOT NULL GROUP BY [Division]